cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
geetha1a2b3c
‎05-09-2018
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Concatenate datasets as it get created

by Calcite | Level 5 in SAS Programming
‎05-08-2018 04:20 AM
‎05-08-2018 04:20 AM
For example if run the code based on period. For example %let date =201701; i want to create new dataset sample.new_sum and this dataset should contain all the previous dates dataset, as 201701 dataset is newly created ... View more

Concatenate datasets as it get created

by Calcite | Level 5 in SAS Programming
‎05-08-2018 03:52 AM
‎05-08-2018 03:52 AM
I have dataset getting created every 6months.   s_200806 s_200812 s_200906 s_200912   Now if i run for period 201706, it will create s_201706   So my start date is 200806   %let start =200806; %let end=201006   i want to cancatenate all the dataset from start date to end into new dataset.   data new; set s_200806 s_200812 s_200906 s_200912 s_200906 s_200912 s_201006 ; run;   So if i run for period 201012, again i have to write the code.   data new; set s_200806 s_200812 s_200906 s_200912 s_200906 s_200912 s_201006 s_201012 ; run;   What i am looking is just create macro loop to concatenate every six month dataset just changing start and end macro. ... View more

Re: Create macro dates in loop

by Calcite | Level 5 in SAS Programming
‎05-07-2018 09:06 AM
‎05-07-2018 09:06 AM
I am trying use the above resolved like %let perf=12; %macro addall(dname,rrun); %do j=1 %to &rrun; %let z=%sysfunc(putn,(&j,z2.)); &dname._&&mon.&z; %end; %mend addall; data new1; set %addall(new,&perf.); run; Getting below error data new1; 64 65 set %addall(new,&perf.); ERROR: Expected open parenthesis after macro function name not found. NOTE: Line generated by the macro variable "Z". 65 mon.(1,z2.)) _ _ 22 22 200 ERROR 22-7: Invalid option name 1. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: Line generated by the macro variable "Z". 65 new_&mon. _ 22 200 WARNING: Apparent symbolic reference MON not resolved. ERROR: Expected open parenthesis after macro function name not found. NOTE: Line generated by the macro variable "Z". 65 new_&mon. ____ 180 WARNING: Apparent symbolic reference MON not resolved. ERROR: Expected open parenthesis after macro function name not found. NOTE: Line generated by the macro variable "Z". 65 new_&mon. ____ 180 WARNING: Apparent symbolic reference MON not resolved. ERROR: Expected open parenthesis after macro function name not found. NOTE: Line generated by the macro variable "Z". 65 new_&mon. ____ 180 WARNING: Apparent symbolic reference MON not resolved. ERROR: Expected open parenthesis after macro function name not found. NOTE: Line generated by the macro variable "Z". 65 new_&mon. ____ 180 WARNING: Apparent symbolic reference MON not resolved. ERROR: Expected open parenthesis after macro function name not found. NOTE: Line generated by the macro variable "Z". 65 new_&mon. ____ 180 WARNING: Apparent symbolic reference MON not resolved. ERROR: Expected open parenthesis after macro function name not found. NOTE: Line generated by the macro variable "Z". 65 new_&mon. ____ 180 WARNING: Apparent symbolic reference MON not resolved. ERROR: Expected open parenthesis after macro function name not found. NOTE: Line generated by the macro variable "Z". 65 new_&mon. ____ 180 ... View more

Re: Create macro dates in loop

by Calcite | Level 5 in SAS Programming
‎05-07-2018 08:09 AM
‎05-07-2018 08:09 AM
Thanks draycut. I am looking for what went wrong. Why iam getting different result.I gonna use 'mon'||put(i,z2.) in later part of my code ... View more

Create macro dates in loop

by Calcite | Level 5 in SAS Programming
‎05-07-2018 07:55 AM
‎05-07-2018 07:55 AM
I wrote below part to get the third month from date macro.   %let date=2017-01-01; %let a_SASdate=%sysfunc(inputn(&date.,yymmdd10.)) ; %let b=%sysfunc(putn(&a_SASdate.,yymmn6.)) ; %let et=%sysfunc(intnx(month,%sysfunc(inputn(&date.,yymmdd10.)),2,s),yymmn6.); %put &a_SASdate. &b. &et.; I wrote below code to create macro variable for each date.   data new; do i=1 to 12; call symput('mon'||put(i,z2.),put(intnx('month',&et.,i),yymmn6.)); a=symget('mon'||put(i,z2.)); output; end; run; Expected output   i a 1 201704 2 201705 3 201706 4 201707 5 201708 6 201709 7 201710 8 201711 9 201712 10 201801 11 201801 12 201803 But what iam getting is   1 251204 2 251205 3 251206 4 251207 5 251208 6 251209 7 251210 8 251211 9 251212 10 251301 11 251302 12 251303 What went wrong? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-09-2018 08:52 AM
Quick links