Hello,   I have dataset like below. I would like to create a macro which can loop from 1 to _n_ to create a serial of new datasets with name "output_x" where x is the row number.  For example : data output_1; set raw.ds1; keep var1; run; data output_2; set raw.ds2; keep var2; run; ... Could anyone guide me on this? Feels like array might be the way to do. I am very new to array concept and could not figure out by myself.  Please help.   If there is a better/smarter way other than using array, please also share your thoughts. Thanks.   data have; input LIB $ DS $ VAR $; datalines; RAW DS1 VAR1 RAW DS2 VAR2 WORK DS1 VAR2 WORK DS1 VAR3 WORK TF1 VAR4 RAW FT15 VAR5 ; run;     ... View more

Hello,   I would like to get the variables that contain "_raw" in my folder. I tried  to utilized vcolumn but got following error message. Could anyone told me how to work around it?    data varlst; set sashelp.vcolumn; if libname = 'RAW' and index(name,'_RAW') ; keep memname name label; run; ERROR: Some character data was lost during transcoding in the dataset RAW.XXX. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding. ERROR: SQL View SASHELP.VCOLUMN could not be processed. ... View more

Hello,   Please pardon me if this question is too silly.   I could run following code in interactive mode but got following warning in batch mode. Why? How can I run this in batch mode? %let _source=%sysget(sas_execfilepath); WARNING: The argument to macro function %SYSGET is not defined as a system variable.   ... View more

Hello, I try to modify my 'Have' data to 'Want'.  I tried and it looks like I need to do subset and then merge, or transpose then subset and merge. Is it a smart way to do it all at once? If you were me, what will you do?   data have; input group $ order L1 L2 ; datalines; A1 1 45 36 A1 2 25 55 A2 1 88 99 A2 2 74 78 A3 1 4 . 25 A3 2 88 99 B4 1 78 65 B4 2 . . ; run; ... View more