date format from sas to WPS

haricot groui

Hello,

 

I want to put date format for few variables thanks to a macro variable var_date. This is the program in sas to create macro variable var_date:

 

                    PROC SQL NOPRINT;
                        SELECT CATX("","'",NAME,"'n ='ddmmyy10.'") INTO :var_date SEPARATED BY ' '
                        FROM DICTIONARY.COLUMNS
                        WHERE upcase(FORMAT) = "DATETIME20."
                        AND MEMNAME = "TEST";    
                    QUIT;

After i want to put format date but in WPS, it displays an error message after this program:

                    PROC SQL NOPRINT;
                        CREATE TABLE ONG_COURT AS
                        SELECT * 
                        FROM RESULT.F_L (sasdatefmt=(&var_date.));
                    QUIT;

 

ERROR: Expected a format, found 'ddmmyy10.'

 

With var_date= "120"n ='ddmmyy10.'

 

Someone can help me please? 

 

thank you

 

Katia

Payal Pawar_20288

Hi,

Please let me know which Altair product you are using so that I can direct your question to the proper forum.