🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

date format from sas to WPS

User: "haricot groui"
New Altair Community Member
Updated by 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

Find more posts tagged with

Sort by:
1 - 1 of 11