Hi All, I need to concatenate almost 100 variables and I don't want to put a comma (,) after each one of them as it is too much of work. My variables has a sequence and it follows the pattern like var1, var2, var5, var11......   Is there a way to concatenate all of them with a short code like new_Var=CAT(var1-var100)   Here is how my data looks like. DATA Have; INPUT VAR1 VAR2$ VAR5 VAR10$; DATALINES; 107 ENG1 10 NY 105 Bio2 15 ON 101 Che1 10 TX 107 Bio1 11 DL 105 Eng2 15 CA 100 Phy2 11 MR 105 Che1 15 DC ; RUN   Can someone help me please.   Thanks,   ... View more

Hi All, I have some stored IDs that I need to assign to my observations. At the end I also want to disappear those IDs from that ID table and update that table.     DATA Have; INPUT Course_ID$ age State$; DATALINES; ENG1 15 NY Che1 10 NY Eng2 15 CA Phy2 11 PA Che1 15 TX ; RUN; DATA ids; INPUT slno; DATALINES; 107 101 105 116 264 552 145 235 224 117 100 ; RUN; PROC SORT DATA=ids; BY slno; RUN; At the end I want the table 'Have' to be populated with slno from 'ids' table and lname it as want:     Want slno   course_ID  Age State 100   ENG1         15     NY 101   Che1           10    NY 105   Eng2           15    CA 107   Phy2           11    PA 116   Che1           15    TX     Also, at the end ids table should stay with the remaining slno:   ids slno 117 145 224 235 264 552     Thanks for your help in advance ... View more

Hi All, I am trying to copy a column and format it in MMDDYY10. format, but it look like the first observation on the additional column remain blank. DATA Want Second_Date=First_Date; Format Second_Date MMDDYY10. SET Have RUN; ID      First_Bate      Second_Date 101   12/26/2016           . 202   11/25/2015     12/26/2016 303   10/11/2014     11/25/2015 404    09/14/2013    10/11/2014   I will really appreciate if anyone can give me a clue.   Thank You. ... View more

Hi All, I am trying to copy files from the FTP server to SAS. Can someone please help. Folowing the are code that I wrote. Thanks.      FILENAME TEST FTP 'Test.xlsx' lrecl=256 CD='/44434/Data/' HOST='files1.abc.com' USER='anonymous' PASS='XXXX'; RUN; PROC PRINT DATA=Test; RUN; ... View more