SAS Support Communities

LNEW · ‎04-06-2021

Our client requested datasets of each school. I have exported the data from REDCap into SAS. I was able to find my way ... and now have good results. DATA _NULL_; if _n_ = 1 then do; if 0 then set redcap2; declare hash eachschool (dataset: 'redcap2(obs = 0)' , multidata: 'y'); eachschool.definekey (all: 'yes'); eachschool.definedata (all: 'YES'); eachschool.definedone (); end; do until (last.pc); set redcap2; by pc cn; eachschool.add(); end; eachschool.output (dataset: compress ('PCSample'||pc)); eachschool.clear(); run;

LNEW · ‎04-06-2021

I have a data set with a survey_identifier (school/class) which looks like 1_1_ for school 1, class 1 in which there will be many students. And I will have numerous schools with many class numbers. So for instance I will have 25 rows with 1_1_ because 25 students will be in that class. I am trying to use a Hash procedure to create separate data sets for each school but am getting an error "Uninitialized object at line 1030 column 16." Can someone help me figure out the issue. I have DATA _NULL_; declare hash eachschool (dataset: 'redcap1', ordered: 'Y'); eachschool.definekey ('redcap_survey_identifier', 'cn'); eachschool.definedata (all: 'YES'); eachschool.definedone (); declare hiter heach ('eachschool'); declare hash hashnum; do until (done); set redcap1 end = done; if eachschool.check () then do; hashnum = _new_ hash (ordered: "Y"); hashnum.definekey ('redcap_survey_identifier', 'cn'); hashnum.definedata (all: "YES"); hashnum.definedone (); rc = eachschool.replace(); end; rc=eachschool.find(); rc=hashnum.replace(); /*THIS IS THE LINE GIVING ME THE ERROR*/ end; do while (heach.next() = 0); rc= hashnum.output (dataset: "school"||redcap_survey_identifier); end; stop; run;

LNEW · ‎04-18-2019

Thanks, I have bookmarked this page.

LNEW · ‎04-17-2019

Here's a thought: Proc sql; create table first_set_only as select var1, var2 from dsn1 where id in (select id from work.ids); quit; %let set_list = dsn2 dsn3...dsn60; %macro app; do i = 1 %to 59; Proc sql; create table &set_list._1 as select var1, var2 from &set_list where id in (select id from work.ids); quit; 　 proc append base = first_set_only data = &set_list._1 force; proc append base = first_set_only data = &set_list._1 force; proc append base = first_set_only date = &set_list._1 force; %end; %mend; %app;

LNEW · ‎04-16-2019

try substrn for numeric variable.

LNEW · ‎04-11-2019

by year descending sales;

LNEW · ‎04-11-2019

try this instead in the proc sort before the proc report statement. proc sort data = salesbyproductbydate out = salesbyproductbydate_2; by year sales; run; reference new dataset salesbyproductbydate_2 your month refers to date. It does not refer to low to high amounts this too could be part of the issue.

LNEW · ‎04-11-2019

I think sorting before using the report would work. Then reference the new report name. Let me know if this works. data salesbyproductbydate; set salesbyproductbydate; year = YEAR(date); month = Month(date); run; proc sort data = salesbyproductbydate out = salesbyproductbydate_1; by year descending sales; run;

LNEW · ‎04-11-2019

"descending" should go in before sales in your proc sort statement. PROC SORT DATA=data; by descending sales ; RUN;

LNEW · ‎04-11-2019

With proc format you would have a repeated or overlap of values for 0. The simplest way I saw from using your information was creating a dataset with a category variable. data val; input LDH; datalines; 56 25 0 0 ; run; data val1; length Category $15; set val; if LDH >25 then do; Category = "LDH Normal"; end; if LDH = 25 then do; Category = "LDH > 1XNormal"; end; if LDH = 0 then do; Category = "LDH > 2XNorma"; end; if LDH = 0 then do; Category = "LDH > 3XNormal"; end; run;

LNEW · ‎04-11-2019

You could try using the lag function: datebefore = lag(date);

LNEW · ‎09-01-2017

This is what I ran and the results were spot on. Thank you. ods path sashelp.tmplmst(read) sasuser.templat(update); ods path sashelp.tmplmst(read); proc datasets library=sasuser nolist; delete templat(memtype=itemstor); run; ods path sasuser.templat(update) sashelp.tmplmst(read); 　 proc template; list base.freq.onewayfreqs; quit;

LNEW · ‎09-01-2017

Thanks so much. This is what I ran and the results were spot on. ods path sashelp.tmplmst(read) sasuser.templat(update); ods path sashelp.tmplmst(read); proc datasets library=sasuser nolist; delete templat(memtype=itemstor); run; ods path sasuser.templat(update) sashelp.tmplmst(read); proc template; list base.freq.onewayfreqs; quit;

LNEW · ‎08-31-2017

ODS RTF FILE = 'S:\blahblah\frequencies.RTF' STYLE = BARRETTSBLUE STARTPAGE = NO; ODS NOPROCTITLE; %MACRO PRINTFREQ (VAR = ); PROC FREQ DATA =dat._3_subset; TABLES &VAR.; WHERE &VAR. NOT IN ('7', '8', '9', '77', '88', '99'); RUN; %MEND PRINTFREQ; %PRINTFREQ (VAR=Q1) %PRINTFREQ (VAR=Q2) %PRINTFREQ (VAR=Q3) I am using 9.4 X64_7PRO platform X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation As you can see in the attachment my output has two percent columns. Can someone tell me why I am getting two percent columns in the output and also why I am not getting a decimal in the percent column? Is it a settings issue? Can you assist me in resetting if needed? Thanks. L

Online Status	Offline
Date Last Visited	‎02-22-2024 03:32 PM

SAS Support Communities

Re: Hash Table Subsetting Question

Hash Table Subsetting Question

Re: How to get a fast, helpful answer to your SAS questions

Re: SQL to Filter with an existing table

Re: Proc SQL Substring of a numeric variable

Re: Sort sales ascending

Re: Sort sales ascending

Re: Sort sales ascending

Re: Sort sales ascending

Re: Display all values

Re: Early Weather Forecast for SASGF 19 in Dalla

Re: Early Weather Forecast for SASGF 19 in Dalla

Is there an orientation for first timers during the conference?

How to get a fast, helpful answer to your SAS questions

Re: You TOO can earn communities swag! Here’s how

Re: Early Weather Forecast for SASGF 19 in Dalla

Re: Everybody needs Career Development

Re: How to get a fast, helpful answer to your SAS questions

Re: You TOO can earn communities swag! Here’s how

Re: You TOO can earn communities swag! Here’s how

Re: Hash Table Subsetting Question

Hash Table Subsetting Question

Re: How to get a fast, helpful answer to your SAS questions

Re: SQL to Filter with an existing table

Re: Proc SQL Substring of a numeric variable

Re: Sort sales ascending

Re: Sort sales ascending

Re: Sort sales ascending

Re: Sort sales ascending

Re: Display all values

Re: Data step to compare date value with its predecessor line value

Re: Duplicate percent column in Frequency table, missing decimal in pe...

Re: Duplicate percent column in Frequency table, missing decimal in pe...

Duplicate percent column in Frequency table, missing decimal in percen...

SAS Analytics Explorers

SAS Global Forum 2019

Follow Us

What is...