About Harmandeep

Harmandeep · ‎08-25-2017

Hi, I am working on creating some good report by using proc report procedures and ODS PDF. I need Best Practices one should follow to generate good PDF reports.

Harmandeep · ‎08-25-2017

Hi, I am trying to Merge the two data sets Data example1; Input company$ employee age amount prob month; datalines; ABC 01 24 50000 90 5 ABC 01 24 0 10 7 ; data example2; Input company$ employee age amount prob month; datalines; ABC 03 25 21000 90 5 ABC 03 25 0 10 7 ; run; Proc sql; create table combined as select a.company,a.employee,a.amount as ex1_amount,b.amount as ex2_amount,a.prob,a.month from example1 as a left join example2 as b on a.company=b.company; quit; Expected Output: ABC 1 50000 21000 90 5 ABC 1 0 0 10 7

Harmandeep · ‎08-20-2017

This problem can be simplified by using a subquery for the count of total number of variable as : DATA Have; Length Variable_ID $ 3 Variable $ 3; Infile Datalines Missover Dlm=","; Input Variable_ID Variable; Datalines; 001,TUR 001,TUR 002,TUR 002,TUR 003,ENG 003,ENG 004,GER 004,GER 005,FRA 005,FRA ; Run; Proc sql; create table want as select Variable, (Count(Variable) / (Select Count(Variable) from have)) * 100 as Percent from have group by Variable; quit;

Harmandeep · ‎08-15-2017

You can first create a list of columns from the vcolumns dataset Select name into :List separated by ',' from sashelp.vcolumn where upcase(memname) ='<Dataset>' and (name like '%_M4' or name like '%_M5' or name like '%_M6'); Then you can use the the created list for creating a table having cloumns that are present in the List as Create table <TableName> as select &List from <dataset>; I hope this might Help.

Harmandeep · ‎08-15-2017

Hi, I am trying to subset dataset based on the ranges in the dataset. I have done subsetting using Data step as : DATA lt_15k lt_20k lt_30k lt_40k gt_40k; set sas1.cars; if price le 15 then Output lt_15k; if (15<price<=20) then Output lt_20k; if (20<price<=30) then Output lt_30k; if (30<price<=40) then Output lt_40k; if (price>40) then output gt_40k; run; I want same results by using Proc SQL command. Is possible to create multiple dataset using proc sql.

Online Status	Offline
Date Last Visited	‎09-12-2017 02:53 AM

ODS for pdf report

Merging/Joining Datasets

Re: How to Calculate Percentage with a PROC SQL

Re: subsetting data using proc sql

Subsetting Dataset using Proc sql

Re: Merging/Joining Datasets

Re: Subsetting Dataset using Proc sql

ODS for pdf report

Merging/Joining Datasets

Re: How to Calculate Percentage with a PROC SQL

Re: subsetting data using proc sql

Subsetting Dataset using Proc sql