Here is my code and I attached the output. Some of the data only extracted 3 digits and then randomly switches to extracting 4 digits?
This is the problem i am solving
data hi.question4;
infile 'C:\Users\larkj\Desktop\STUDENT.DAT';
input ssn 1-9;
SSNc = put(ssn,9.);
drop SSN;
rename SSNc = SSN;
SSN_New=substr(SSNc,1,4);
run;
proc sort data = hi.question4
dupout = SSN_New
nodupkey;
by SSN_NEW;
run;
proc print data=hi.question4;
run;
Your datastep doesn't make sense. Read SSN as a character from start, don't convert it.
And the subject line doesn't make sense for your question either...
Your datastep doesn't make sense. Read SSN as a character from start, don't convert it.
And the subject line doesn't make sense for your question either...
That worked great, don't know why I didn't do that before. Thank you
If you had wanted to keep using the previous code, use Z9 to apply a 9 digit format with leading 0s.
You can read the SSN as a character string.
input SSNc $9. ;
You can convert a numeric value to 9 digits with leading zeros using the Z9 format.
SSNc = put(ssn,Z9.);
You can get the first 4 digits of a 9 digit number using arithmetic.
prefix = int(ssn/10000);
You can get the first 4 characters of a 9 character string using SUBSTR().
prefixc = substr(SSNc,1,4);
@larkjr18 wrote:
Here is my code and I attached the output. Some of the data only extracted 3 digits and then randomly switches to extracting 4 digits?
This is the problem i am solving
- Consider only the first 4 character digits of SSN, find the duplicate groups through By-group processing, and create a SAS data set for these observations. Present the screenshot of the partial SAS LOG, showing the number of observations in this subset of data. Show the output for “corrected SSN” variable using PROC PRINT (OBS=8);”.
data hi.question4;
infile 'C:\Users\larkj\Desktop\STUDENT.DAT';
input ssn 1-9;
SSNc = put(ssn,9.);
drop SSN;
rename SSNc = SSN;
SSN_New=substr(SSNc,1,4);
run;
proc sort data = hi.question4
dupout = SSN_New
nodupkey;
by SSN_NEW;
run;
proc print data=hi.question4;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.