What your rules for "have the names same as it is in csv file"?
Do you want to include the .csv in the dataset names? SAS names do not normally allow periods.
Let's assume you meant you wanted to remove the .csv from the end of the name.
What about names with other invalid characters, like hyphens or spaces?
What about names that start with a digit?
To remove the .csv once you have found it is simple. If you are positive there is only one period in the name just use SCAN() again with 1 instead of -1 as the index. Otherwise use SUBSTR() to to remove the last 4 characters (the length of &ext plus 1).
... View more
Before creating a macro to GENERATE SAS code you need to know what SAS code you want to generate.
So please show the code you want to run for each of the three macro calls you have.
Please write it out yourself before clicking on the SPOILER link below.
/* %RRR(value='Asia'); */
data tbl_asia;
set sashelp.cars;
where origin="Asia";
run;
/* %RRR(value='Europe'); */
data tbl_europe;
set sashelp.cars;
where origin="Europe";
run;
/* %RRR(value='All'); */
data tbl_all;
set sashelp.cars;
run;
Once you can make the code for the three cases then you can check and see if there is a pattern in the code that might make it possible for you to use macro logic to generate the proper code based on the input parameters you decide to create.
... View more
Perhaps you should show use YOUR metadata data set and a small example of your "final data" and then what you expect for a result given those two example sets.
I am afraid that I can't guess what you actually want. Your example doesn't attempt to match or drop anything so it isn't clear what you mean by " keep variables which are in final data and drop the remaining" or why you think transpose is needed/wanted.
@noda6003 wrote:
I have metadata with variables and then want to append it with my final data and only keep variables which are in final data and drop the remaining. when i do proc contents on metadata and transpose then all the variables are becoming numeric and i couldnt merge it with my final data. can you please help on how to do it.
proc contents
data = sashelp.class
noprint
out = tmp (keep = name);
run;
proc transpose data=tmp out=tmp1(drop=_name_);
id name;
run;
... View more
I'd use the IFN function:
data want;
set book1;
by pid;
anl = ifn(first.pid,.,stdt - lag(est));
run;
All arguments to IFN are evaluated before the condition in the first argument is applied, so LAG will always correctly fill its queue.
... View more
Tell the INPUT() function to use the full length of the string instead of truncating at 9 characters.
data have;
input char_date $11.;
cards;
22 DEC 2020
2 FEB 2021
;
data want;
set have;
date = input(char_date,date11.);
format date date9. ;
run;
Obs char_date date
1 22 DEC 2020 22DEC2020
2 2 FEB 2021 02FEB2021
... View more
With a data step.
data have1;
input ID;
datalines;
1
2
3
4
;
data have2;
input TEXT $;
datalines;
Height
Weight
;
data want;
set have1;
do i=1 to n;
set have2 point=i nobs=n;
output;
end;
run;
Result:
ID TEXT
1 Height
1 Weight
2 Height
2 Weight
3 Height
3 Weight
4 Height
4 Weight
... View more
proc sgscatter data=sashelp.iris(where=(species="Virginica"));
title "Multi-Celled Spline Curve for Species Virginica";
plot (sepallength sepalwidth)*(petallength petalwidth)
/ pbspline;
run;
... View more
Thanks a lot, it works pretty much except ordering which i gave grouporder=ascending and i created order variable ord and it was ordered at final step but it misses
... View more
I don't know what you mean by "2 Groups". Bot I think you want to do this
data have;
input cnt_subj trt $ EOSE;
datalines;
1 X1D1 0.3
11 X1D1 1
1 X1D15 3
3 X1D15 10
4 X1D15 30
5 X1D8 3
5 X1D8 10
;
data want;
do until (last.trt);
set have;
by trt;
cnt + cnt_subj;
end;
do until (last.trt);
set have;
by trt;
output;
end;
cnt = 0;
run;
Result:
cnt_subj trt EOSE cnt
1 X1D1 0.3 12
11 X1D1 1.0 12
1 X1D15 3.0 8
3 X1D15 10.0 8
4 X1D15 30.0 8
5 X1D8 3.0 10
5 X1D8 10.0 10
... View more
@noda6003 wrote:
Can you help me on where to find sas program to convert dataset to sas code to post as example in community
Thank you @noda6003 for wanting to provide the data to the rest of the community in a usable form! This is great, I commend you and give you three emojis! 👍🖖🙌
... View more
good attempt @noda6003 just a tweak-
data have;
input var1-var3;
cards;
1 2 .
1 3 2
2 1 3
;
data want;
set have;
length want $10;
want=catx('/',var1,var2,ifc(var3=.,'Y',put(var3,8.)));
run;
... View more
HI @noda6003 Please try using
BESTDw.p Format
https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=leforinforref&docsetTarget=n0wi1eyjui7p3fn1g7912tl3lqyg.htm&locale=en
... View more
