About Linlin

Linlin · ‎04-12-2013

data have; input v$; cards; abc -bc a-b ; data want; set have; v=ifc(first(v)='-',compress(v,'-'),v); proc print;run;

Linlin · ‎04-11-2013

read SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Linlin · ‎04-10-2013

example: data have; input date mmddyy10. v; format date mmddyy10.; cards; 10/31/2010 8 12/31/2010 9 10/31/2011 9 12/31/2011 10 01/31/2012 15 ; data want; retain nv .; set have; if month(date)=12 then nv=v; new=lag(nv); proc print;run;

Linlin · ‎04-08-2013

I had a similar problem when I installed 9.3 some time ago. a type of HP printer as my default printer caused the problem.

Linlin · ‎04-05-2013

Hi, You have to use double " " when macro variables are involved. ods &styl file='C:\Users\sas\Desktop\discharge_print.&styl ';

Linlin · ‎04-04-2013

I think so. make sure your "old_data" dataset is the same as your "new" dataset (the cumulative one you created by running your macro); %macro combdsets; %do i=1 %to &count; proc append base=new data=abc.&&name&i force; run; %end; %mend combdsets; After I do that every month fresh data is appended by : %macro append_monthly(new_data=); proc append base=old_data data=&new_data; run; %mend;

Linlin · ‎04-04-2013

Yes, it creates macro variables &id1,&id2,....; example: data have; input sex$ ; cards; f m f ; data _null_; set have; call symputx(cats('id',_n_),sex); run; %put &id1; %put &id2; %put &id3; /* log file */ 440 data have; 441 input sex$ ; 442 cards; NOTE: The data set WORK.HAVE has 3 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 446 ; 447 data _null_; 448 set have; 449 call symputx(cats('id',_n_),sex); 450 run; NOTE: There were 3 observations read from the data set WORK.HAVE. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 451 %put &id1; f 452 %put &id2; m 453 %put &id3; f

Linlin · ‎04-04-2013

try this: data class; set sashelp.class; postion_of_observation=_n_; proc print;run;

Linlin · ‎04-03-2013

you have to use proc sort. below is the output without proc sort: libname abc "c:\temp"; /* change the directory if necessary. there should not be any other datasets in this dir. */ data abc.data1 abc.data2 abc.data3; set sashelp.class; run; proc contents data=abc._all_ out=abccont(keep=memname name) noprint;run; /* memname is dataset name */ proc print data=abccont;run; Obs MEMNAME NAME 1 DATA1 Age 2 DATA1 Height 3 DATA1 Name 4 DATA1 Sex 5 DATA1 Weight 6 DATA2 Age 7 DATA2 Height 8 DATA2 Name 9 DATA2 Sex 10 DATA2 Weight 11 DATA3 Age 12 DATA3 Height 13 DATA3 Name 14 DATA3 Sex 15 DATA3 Weight

Linlin · ‎04-03-2013

abccont is the dataset name just created. memname is a variable of dataset abccont, the values of memname are all the dataset names in the library.

Linlin · ‎04-03-2013

Congratulations DN!!!

Linlin · ‎04-03-2013

Hi, try the code below. libname abc "c:\temp"; /* change the directory if necessary. there should not be any other datasets in this dir. */ data abc.data1 abc.data2 abc.data3; set sashelp.class; run; proc contents data=abc._all_ out=abccont(keep=memname) noprint;run; /* memname is dataset name */ proc sort data=abccont nodupkey; by memname; run; data _null_; set abccont end=last; call symputx(cats('name',_n_),memname); if last then call symputx('count',_n_); run; %put _user_; /* allow you to see the macro variables in log file */ %macro combdsets; %do i=1 %to &count; proc append base=new data=abc.&&name&i force; /*after running this macro step "NEW" dataset is created which has three datasets(data1,data2,data3) */ run; %end; %mend combdsets; %combdsets

Linlin · ‎03-28-2013

Hi PG, I tried. I can only insert a row from a table not the whole table. Sorry.

Linlin · ‎03-28-2013

Hi PG, Do you think mail merge would work?

Linlin · ‎03-25-2013

Hi, It works for me. below is my log file. 1 options minoperator mindelimiter=','; 2 %Let ak = abd2005; 3 %Macro year; 4 %If &ak in %str(abd2001,abd2005) %then 5 %do; 6 %Put &ak.; 7 %end; 8 %Mend; 9 %year; abd2005

Online Status	Offline
Date Last Visited	‎12-04-2020 11:18 PM

Re: How to put sas outputs into word file?

How to put sas outputs into word file?

Re: missing data

missing data

Re: Congratulations Fareeza!

Re: Capturing the last character in a variable value

Re: How to split one string into multiple rows?

Re: can't insert date macro into SQL

Re: Two consecutive visit records, Flag first record

Re: First and last day of month using Macros in proc sql

Re: How to count number of of call in the a week

Re: How to count number of of call in the a week

Re: Can someone help me with the following please?

Re: Can someone help me with the following please?

Re: Concatenate with CATX

Re: How to force two outputs from proc report on one page and keep dif...

Re: solution for loop

Re: I am trying to merge two files and don’t want to get rid of the du...

IN Dataset option

Re: convert month in num

Re: Removing string - in the data

Re: Help to calculate weekly standard deviation from daily price panel...

Re: how can I create an extra variable?

Re: Libname error with excel engine

Re: ods &styl file='C:\Users\sas\Desktop\discharge_print.xml';

Re: Understanding the code for Appending several datasets

Re: Understanding Call Symput!

Re: Understanding Call Symput!

Re: Understanding the code for Appending several datasets

Re: Understanding the code for Appending several datasets

Re: how to identify a time variable (time5. format) is num or char, no...

Re: Understanding the code for Appending several datasets

Re: Link to SAS tables from a Word report

Re: Link to SAS tables from a Word report

Re: Macro variable check